Intro

As part of Vivo Data Analytics screening, I was handed an simulated Excel Data and was challenged to provide Sales Insight, the Data consist of 2 main tables, first is a time series of April Sales, the second is sales summary of multiple products through different distributed channels.

A look at the data after being processed for our analysis

April TimeSeries







First Quarter







April Analysis

As we can see from the chart bellow, sales was higher at the beginning of April and during the last 2 days. FF Model accounted for 38% of Total Sales







First Quarter

The Bar-Graph bellow shows the total quantity sold for each Model in the first Quarter, Febraury Had a huge spike in the sold quantities which positively correlates with Sales-Through of 30 per Model.